package com.woniuxy.caradmin.mapper;

import com.woniuxy.caradmin.entity.pojo.Vehiclefiles;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author womenzu
 * @since 2020-12-07
 */
@Repository
public interface VehiclefilesMapper {
    //根据车牌号查询车辆信息--关联加油记录--关联违章记录
    public Vehiclefiles selectVehiclefilesByVehiclenum(@Param("vehiclenum")String vehiclenum);


    /*查询所有车辆*/
    public List<Vehiclefiles> selectVehicleAll();
    //车辆分页
    public List<Vehiclefiles> selectVehicleByPage(Vehiclefiles vehiclefiles);
    //根据id查询车辆
    public Vehiclefiles selecctVehicleById(@Param("id") Integer id);
    //根据id查询车辆2
    public Vehiclefiles selecctVehicleByIdType(@Param("id") Integer id);
    //增加车辆
    public int addVehiclefiles(Vehiclefiles vehiclefilesAdd);
    //删除车辆：软删，更新数据库表中vehiclefiles的available的值
    public int removeVehicleById(@Param("id")Integer id);
    //查询可用车辆
    public List<Vehiclefiles> selectVehiclefilesByUseble();
    //修改车辆
    public boolean updateVehiclefiles(Vehiclefiles Vehiclefiles);
    public int addVehicle(Vehiclefiles vehiclefilesAdd);
    //根据状态查询所有车辆
    List<Vehiclefiles> statusCarAll(Integer empLevel);
    //根据id修改当前车辆的状态
    void updateVehicleById(Integer vehid);
    //更新车辆图片-夏凯
    public int updateVehiclefilesImg(Vehiclefiles Vehiclefiles);

}
